Tabela StockLotBlockade

Definicja tabeli StockLotBlockade

Name

StockLotBlockade

Code

StockLotBlockade

Comment

Tabela do przechowywania inf. o zablokowanych partiach zasobów/leków


Lista kolumn tabeli StockLotBlockade

Name

Code

StockLotBlockadeID

StockLotBlockadeID

SeriesDataID

SeriesDataID

StockItemID

StockItemID

StockEntryDocumentItemID

StockEntryDocumentItemID

Blocked

Blocked

Active

Active

Comments

Comments


Kolumna StockLotBlockadeID tabeli StockLotBlockade

Definicja kolumny StockLotBlockadeID tabeli StockLotBlockade

Name

StockLotBlockadeID

Code

StockLotBlockadeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna SeriesDataID tabeli StockLotBlockade

Definicja kolumny SeriesDataID tabeli StockLotBlockade

Name

SeriesDataID

Code

SeriesDataID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID serii zasobu


Kolumna StockItemID tabeli StockLotBlockade

Definicja kolumny StockItemID tabeli StockLotBlockade

Name

StockItemID

Code

StockItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID zasobu


Kolumna StockEntryDocumentItemID tabeli StockLotBlockade

Definicja kolumny StockEntryDocumentItemID tabeli StockLotBlockade

Name

StockEntryDocumentItemID

Code

StockEntryDocumentItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID partii magazynowej


Kolumna Blocked tabeli StockLotBlockade

Definicja kolumny Blocked tabeli StockLotBlockade

Name

Blocked

Code

Blocked

Data Type

NUMBER(1)

Mandatory

Yes

Comment

pole 0/1 swiadczace o blokadzie


Kolumna Active tabeli StockLotBlockade

Definicja kolumny Active tabeli StockLotBlockade

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

No

Comment

aktywnosc blokady


Kolumna Comments tabeli StockLotBlockade

Definicja kolumny Comments tabeli StockLotBlockade

Name

Comments

Code

Comments

Data Type

VARCHAR2(500)

Mandatory

No

Comment

Komentarz do blokady


Lista kluczy tabeli StockLotBlockade

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli StockLotBlockade

Definicja klucza Identifier_1 tabeli StockLotBlockade

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment